大家在查：新手新手独当一面 Myron airborne radar 树人 recognizer superior civilization great sensation Sekhmet 奢华高贵

receive statement

receive statement

receive statement

receive statement

1

A specified RECEIVE statement modifies or returns at least one row to a Service Broker queue .

指定的 RECEIVE 语句至少修改一行或并将其返回到 ServiceBroker 队列。

2

For a given conversation , a RECEIVE statement returns messages with a status of 1 in ascending message_sequence_number order .

对于给定的会话，RECEIVE 语句将返回 status 为 1 的消息，并将消息按 message_sequence_number 的升序排列。

3

If the queue specified in the RECEIVE statement has the queue status set to OFF , the statement fails with a Transact-SQL error .

如果 RECEIVE 语句指定的队列的队列状态设置为 OFF ，则该语句将失败，并返回 Transact-SQL 错误。

5

Number of sessions that are currently waiting within a RECEIVE statement for this queue .

当前正在 RECEIVE 语句中等待此队列的会话数。

6

Specifies that the RECEIVE statement waits for a message to arrive on the queue, if no messages are currently present .

指定如果当前没有消息，则 RECEIVE 语句将等待消息到达队列。

8

The WHERE clause of the RECEIVE statement may only contain search conditions that use conversation_handle or conversation_group_id.

RECEIVE 语句的 WHERE 子句可能只包含使用 conversation_handle 或 conversation_group_id 的搜索条件。

9

TIMEOUT can be specified in the RECEIVE statement or in the GET CONVERSATION GROUP statement .

可以在 RECEIVE 语句或 GETCONVERSATIONGROUP 语句中指定 TIMEOUT 。

10

The RECEIVE statement removes received messages from the queue unless the queue specifies message retention .

RECEIVE 语句将从队列中删除已收到的消息，但队列指定消息保持时除外。

11

All messages returned by a RECEIVE statement belong the same conversation group .

RECEIVE 语句返回的所有消息都属于同一个会话组。

12

If a RECEIVE statement or a GET CONVERSATION GROUP statement specifies an unavailable queue , that statement fails with a Transact-SQL error .

如果 RECEIVE 语句或 GETCONVERSATIONGROUP 语句指定了不可用的队列，则该语句将失败，并出现 Transact-SQL 错误。

13

To receive a message from within a process , you use the receive statement .

要从一个进程内接收一条消息，可使用 receive 语句。

14

15

The result set returned by a RECEIVE statement is implicitly ordered .

将 RECEIVE 语句返回的结果集进行隐式排序。

16

The Receive statement labelled Initiation : this is the target of our unit test initiation .

标记为 Initiation 的 Receive 语句：这是我们单元测试启动的目标。

17

A RECEIVE statement clause , which retrieves one or more messages from a Service Broker queue .

RECEIVE 语句子句，从 ServiceBroker 队列检索一条或多条消息。

18

When the RETENTION setting for the queue is ON , the RECEIVE statement updates the status column to 1 and leaves the messages in the queue .

当队列的 RETENTION 设置为 ON 时，RECEIVE 语句将 status 列更新为 1 ，并使消息留在队列中。

19

Now create the receive statement to output the message (see Listing 7 ).

接下来创建 receive 语句以输出消息（请参见清单 7 ）。

20

The RECEIVE statement reads messages from a queue and returns a result set .

RECEIVE 语句将从队列读取消息并返回结果集。

热词推荐

大家在看